Introduction

The analysis in the report is regarding building certification lodgements in the Townsville local government area. Townsville is a city and a major port area in eastern Queensland, Australia. Two data sets have been combined and used for the analysis from the www.data.gov.au website.

First data set i.e. the building approval details have been extracted from here and includes number of building approvals from 2009 to 2021 and their corresponding details e.g. Decision, Class, Suburb etc. And the second data set i.e. City of Townsville’s Suburb geometry has been extracted from here and includes the geometrical values for these Suburbs.

Project Details

Research Questions

  1. To identify the year with maximum approvals and to analyze the data further to find out the suburb and estimate cost of building with respect to the most popular class in that year. And also find out the category that is most in demand for that class.

  2. To analyze the suburb which was inferred from research question 1 and find out the year for which it had the maximum approvals. Also find out the class that occurred maximum times, category with respect to that class and estimate cost for these particular variables.

Part A

Variable Information and Explanation

Table:1.1 Names

Variable Names
Application Type
Date Of Decision Notice
Decision
Class
Subcategory
Category
Estimated Cost
Suburb
Floor Area
No Of Units
Electoral Division
Latitude
Longitude

Description

Below is the description of the variables used in the dataset:

  • Application type: Here, application for ‘building certification lodgements’.

  • Date of decision notice: The date the building certifier made a notice that the works met the building codes.

  • Decision: Current status of the works as recorded with Council.

  • Class: The building classification as per the list on page one.

  • Sub-category (Council category descriptors): This category is a subdivision of class. Provides information regarding additions, alterations, subdwell etc in it.

  • Category: Townsville City Council has published on its website for a number of years a summary of building approval data using the certain categories.

  • Estimated values: The monetary value of the proposed building work.

  • Suburb: The suburb where the building work is taking place.

  • Floor area: The floor area of the building works in square metres.

  • No. of units: Number of individual units created or demolished by the building works.

  • Electoral Division: The local government electoral division in which the works are occurring.

  • Latitude and Longitude: Geometry dimensions

Part B

Answering Research Question 1

Column

Fig:1.1 Finding Year with maximum approvals as a decision, overall.

Map: 1.2 Finding class occuring in maximum suburbs for approved projects in 2020.

Column

Table: 1.3 Finding class occuring maximum times for approved projects in 2020.

Year Class Count_of_Class
2020 Class 1a 406
2020 Class 10a 275
2020 Class 10b 154
2020 Class 6 25
2020 Class 5 13
2020 Class 9b 13

Results for Fig:1.1 and Fig:1.2

  • In the figure 1.1 the year 2020 has maximum approvals till now.

  • In figure 1.2 using plotly, we observe that Class 1a occurs in maximum suburbs.

Result for Table 1.3

  • Table:1.3 gives us the total count of Class 1a. It shows that Class 1a has the maximum count out of all the other classes.

  • Class 1a includes :Single dwelling, detached house, town house or villa unit.

Section 2

Column

Fig: 2.1 Finding category with maximum counts in Class 1a (approved projects), in 2020

Fig: 2.2 Finding Suburb for Residential category (Class 1a), approved projects in 2020

Column

Table: 2.3 Estimated cost for Kirwan

x
993644

Table: 2.4 Estimated cost for Hermit Park

x
1074668

Table: 2.5 Total estimated cost for research question 1

x
2068312

Section 3

Answering Research Question 2: Finding Year and class that occurs most no. of times for approved projects in Kirwan and Hermit Park, in 2021 and 2020 respectively.

Column

Fig: 3.1 Finding the Year for maximum approvals in Kirwan and Hermit Park.

Column

Table: 3.2 Count of Class in Kirwan in 2021

Year Class Suburb Decision Class_count
2021 Class 10a Kirwan #Approved 31
2021 Class 1a Kirwan #Approved 13
2021 Class 10b Kirwan #Approved 8
2021 Class 5 Kirwan #Approved 2
2021 Class 6 Kirwan #Approved 1
2021 Class 9b Kirwan #Approved 1

Table: 3.3 Count of Class in Hermit Park in 2020

Year Class Suburb Decision Class_count
2020 Class 1a Hermit Park #Approved 18
2020 Class 10a Hermit Park #Approved 4
2020 Class 10b Hermit Park #Approved 3

Section 4

A. Out of Class 10a and Class 1a, finding category that is most in demand for approved projects in Kirwan(2020) and Hermit Park(2021) respectively. B. (Keeping, ‘Decision as Approved’, ‘Category as Residential-Other’,‘Suburbs as Kirwan and Hermit Park’,constant. Keeping ‘Year as 2021’ and ‘Class as 10a’ constant for Kirwan. Keeping ‘Year as 2020’ and ‘Class as 1a’ constant for Hermit Park.)

Column

Fig: 4.1 Count of Categories for their respective Suburbs and Class, For ‘Kirwan’ in Class 10a (2021).

Fig: 4.2 Count of Categories for their respective Suburbs and Class, For ‘Hermit Park’ in Class 1a (2020).

Column

Table: 4.3 Total estimated cost for research question 2 (Kirwan)

Total estimated cost for research question 2 (Kirwan)
x
511371

Table: 4.4 Total estimated cost for research question 2 (Hermit Park)

Total estimated cost for research question 2 (Hermit Park)
x
1074668

Analysis

  • It is evident from both the graphs that the Residential-Other category for approved projects, is in demand for both suburbs and both classes in their respective years.

  • By observing table, we know that the total cost for suburb Kirwan for class 10a approved projects(Residential-Other category) in 2020 is $511,371.

  • And from, we know that the total cost for suburb Hermit Park for class 1a approved projects(Residential-Other category) in 2021 is $1,074,668.

Part A

Column

Chart 1: The result for the first research question is depicted below:

Chart 2: The result for the research question 2, Part A (Reverse analysis for Kirwan) is depicted below:

The result for the research question 2, Part B(Reverse analysis for Hermit Park) is depicted below:

Column

Conclusion from Analysis

  • Here, we observe that, all the components for Hermit Park are common between flowchart and flowchart. In both the flowcharts, best (maximum approvals) year 2020, project Class 1a, category residential-other and cost $1,074,668 are common.

  • We can say that, for research question 2, Part B: the reverse Analysis for result 1 has been successful

Final Result

  • Although, out of the approvals that took place in the year 2020 (best year with maximum approvals), maximum approvals were of Kirwan, but this has not been the case vice-versa and hence there is not much similarity between result 1 and result 2(PartA).

  • For result 1 and result 2(Part B), both the flowcharts are depicting the reverse of each other, giving the same information.

Part B

Row

Column

Credits :

  • Pranali angne (32355068)

  • Nishtha arora (32296622)

  • Raunak bhivpathaki (32230486)

References

[1] D. Kahle and H. Wickham. ggmap: Spatial Visualization with ggplot2. The R Journal, 5(1), 144-161. URL http://journal.r-project.org/archive/2013-1/kahle-wickham.pdf

[2] Original S code by Richard A. Becker, Allan R. Wilks. R version by Ray Brownrigg. Enhancements by Thomas P Minka and Alex Deckmyn. (2018). maps: Draw Geographical Maps. R package version 3.3.0. https://CRAN.R-project.org/package=maps

[3] Hao Zhu (2021). kableExtra: Construct Complex Table with ‘kable’ and Pipe Syntax. R package version 1.3.4. https://CRAN.R-project.org/package=kableExtra

[4] Hadley Wickham and Jim Hester (2020). readr: Read Rectangular Text Data. R package version 1.4.0. https://CRAN.R-project.org/package=readr

[5] C. Sievert. Interactive Web-Based Data Visualization with R, plotly, and shiny. Chapman and Hall/CRC Florida, 2020.

[6] Wickham et al., (2019). Welcome to the tidyverse. Journal of Open Source Software, 4(43), 1686, https://doi.org/10.21105/joss.01686

[7] Garrett Grolemund, Hadley Wickham (2011). Dates and Times Made Easy with lubridate. Journal of Statistical Software, 40(3), 1-25. URL https://www.jstatsoft.org/v40/i03/.

[8] H. Wickham. ggplot2: Elegant Graphics for Data Analysis. Springer-Verlag New York, 2016.

[9] Erich Neuwirth (2014). RColorBrewer: ColorBrewer Palettes. R package version 1.1-2. https://CRAN.R-project.org/package=RColorBrewer

[10] Ron Ammar (2019). randomcoloR: Generate Attractive Random Colors. R package version 1.1.0.1. https://CRAN.R-project.org/package=randomcoloR

[11] Jennifer Bryan (2017). gapminder: Data from Gapminder. R package version 0.3.0. https://CRAN.R-project.org/package=gapminder

[12] Karthik Ram and Hadley Wickham (2018). wesanderson: A Wes Anderson Palette Generator. R package version 0.3.6. https://CRAN.R-project.org/package=wesanderson

[13 Townsville City Council Building Approvals - data.gov.au. (2021). Retrieved 2 June 2021, from https://data.gov.au/data/dataset/tcc-building-approvals

[14] Townsville Suburbs - data.gov.au. (2021). Retrieved 2 June 2021, from https://data.gov.au/dataset/ds-dga-81cbbedc-e35f-4266-980d-21a6159b2404/distribution/dist-dga-28812258-4cf4-46aa-aa43-0206d7c60920/details?q=

[15] RStudio Team (2020). RStudio: Integrated Development for R. RStudio, PBC, Boston, MA URL http://www.rstudio.com/.

[16] GitHub: Where the world builds software. (2021). Retrieved 2 June 2021, from https://github.com/

[17] GitKraken Documentation. (2021). Retrieved 2 June 2021, from https://support.gitkraken.com/start-here/guide/

[18] A hackable text editor for the 21st Century. (2021). Retrieved 2 June 2021, from https://atom.io

[19] Azyyati Marzukhi, M., Jaafar, A. and Ling Hoon Leh, O., 2019. The Effectiveness Of Building Plan Approval. Case Study: Subang Jaya Municipal Council, Selangor. [online] Malaysia. Available at: https://www.matec-conferences.org/articles/matecconf/pdf/2019/15/matecconf_iconbee2019_06005.pdf [Accessed 2 June 2021].